Problem Note 54599: A syntax error might occur when you run a procedure against a SAS® Information Map that references negative numbers
When you run a procedure against a SAS Information Map, you might see errors that are similar to the following:
Error while submitting SAS code
17 ( case when table1.Age in (-1, 11, 12, 14, 15, 16) then 999 else 13 end ) IN ( (-1),
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: (, SELECT.
ERROR 76-322: Syntax error, statement will be ignored.
This error occurs if the information map includes an expression that references negative numbers in an IN clause. For example, if you insert a data item with the following expression into the information map, the error occurs when you attempt to run a procedure against the information map.
insert dataitem
name = 'Student Age'
expression = 'case when <> in (-1, 11, 12, 14, 15, 16) then 999 else 13 end'
type = character
id = 'age';
To resolve this issue, add the following option to the JREOPTIONS section of your sasv9.cfg file. You must be running SAS® 9.4_M2 or later to use the option.
-DSASQueryServices.BiqNoNegParens=Y
Operating System and Release Information
| SAS System | Base SAS | Aster Data nCluster on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| DB2 Universal Database on AIX | 9.3 TS1M0 | 9.4 TS1M2 |
| DB2 Universal Database on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Greenplum on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Netezza TwinFin 32bit blade | 9.3 TS1M0 | 9.4 TS1M2 |
| Netezza TwinFin 32-bit SMP Hosts | 9.3 TS1M0 | 9.4 TS1M2 |
| Netezza TwinFin 64-bit S-Blades | 9.3 TS1M0 | 9.4 TS1M2 |
| Netezza TwinFin 64-bit SMP Hosts | 9.3 TS1M0 | 9.4 TS1M2 |
| Teradata on Linux | 9.3 TS1M0 | 9.4 TS1M2 |
| z/OS | 9.3 TS1M0 | 9.4 TS1M2 |
| Z64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.4 TS1M2 |
| Microsoft Windows Server 2008 R2 | 9.3 TS1M0 | 9.4 TS1M2 |
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Microsoft Windows XP Professional | 9.3 TS1M0 | |
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Professional x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Windows Vista | 9.3 TS1M0 | |
| Windows Vista for x64 | 9.3 TS1M0 | |
| 64-bit Enabled AIX | 9.3 TS1M0 | 9.4 TS1M2 |
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.4 TS1M2 |
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.4 TS1M2 |
| HP-UX IPF | 9.3 TS1M0 | 9.4 TS1M2 |
| Linux | 9.3 TS1M0 | 9.4 TS1M2 |
| Linux for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
| Solaris for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-11-12 10:11:21 |
| Date Created: | 2014-11-11 14:26:25 |